﻿namespace zaklad_rtv
{
    public class StringConstants
    {

        #region PrintableConfirmation constants

        public const string NumberPlaceholder = "###NUMER###";
        public const string NamePlaceholder = "###IMIENAZWISKO###";
        public const string AddressPlaceholder = "###ADRES###";
        public const string TelephonePlaceholder = "###TELEFON###";
        public const string HardwareTypePlaceholder = "###TYPSPRZETU###";
        public const string ServiceDescriptionPlaceholder = "###OPISNAPRAWY###";
        public const string DefectDescriptionPlaceholder = "###OPISUSTERKI###";
        public const string CostPlaceholder = "###KOSZT###";
        public const string BeginServiceDatePlaceholder = "###DATAPRZYJECIA###";
        public const string EndServiceDatePlaceholder = "###DATAODBIORU###";
        public const string RemarksPlaceholder = "###UWAGI###";
        public const string FooterPlaceholder = "###STOPKA###";

        #endregion

        #region Database related constants

        public const string DBFile = "baza.sqlite";

        public const string ClientsCreateQuery = "CREATE TABLE [Client] (" +
                                                 "[id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," +
                                                 "[first_name] NVARCHAR(50) NOT NULL," +
                                                 "[last_name] NVARCHAR(50) NOT NULL," +
                                                 "[telephone] NVARCHAR(50) NULL," +
                                                 "[address] TEXT NULL" +
                                                 ");";

        public const string ServicesCreateQuery = "CREATE TABLE [Service] (" +
                                                  "[id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," +
                                                  "[client_id] INTEGER NOT NULL," +
                                                  "[number] INTEGER NOT NULL," +
                                                  "[hardware_type] TEXT NULL," +
                                                  "[defect_description] TEXT NULL," +
                                                  "[service_description] TEXT NULL," +
                                                  "[remarks] TEXT NULL," +
                                                  "[begin_service_date] DATE NOT NULL," +
                                                  "[end_service_date] DATE NULL," +
                                                  "[cost] INTEGER NOT NULL," +
                                                  "FOREIGN KEY(client_id) REFERENCES Client(id)" +
                                                  ");";

        public const string ConfigCreateQuery = "CREATE TABLE [Config] (" +
                                                "[id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," +
                                                "[config_name] TEXT NOT NULL," +
                                                "[config_description] TEXT NOT NULL," +
                                                "[config_value] TEXT NOT NULL" +
                                                ");";

        #endregion

        #region App Configuration

        public const string ConfigFooterName = "config.footer";
        public const string ConfigFooterDesc = "Stopka wydruku (np. nazwa i adres serwisu)";

        #endregion

        public const string DateFormat = "yyyy-MM-dd";

        public const string Credits = "Serwis RTV \n" +
                                      "Aplikacja wspomagająca prowadzenie serwisu RTV \n\n" +
                                      "Autor: Tomasz Kuzemczak \n" +
                                      "tomasz.kuzemczak@gmail.com \n\n" +
                                      "Ikony: Double-J Design \n" +
                                      "http://www.doublejdesign.co.uk/";
    }
}
